Release 10.1A: OpenEdge Data Management:
Database Administration

Starting and stopping an APW

A database can have between one and nine APWs running simultaneously. The optimal number is highly dependent on your application and environment. Start with two APWs and monitor their performance with PROMON. If there are buffers being flushed at checkpoints, add an additional APW and recheck. Applications that perform fewer changes to a database require fewer APWs. For more information on APWs and how to use PROMON to monitor them, see the "Using APWs to improve performance" section.

Note: If you perform no updates, no page writers are required.

To start an APW process, use Progress Explorer or enter the following command on the local machine:

proapw db-name

Each APW counts as a process connected to a database and uses resources associated with a user. You might have to increase the value of the Number of Users (-n) parameter to allow for APWs. However, APWs are not counted as licensed users.

Stop an APW by disconnecting the process with the PROSHUT command.

For detailed information on the PROAPW and PROSHUT commands, see Chapter 17, " Startup and Shutdown Commands."